﻿CREATE TABLE [dbo].[SiteDoc]
(
	Id bigint Identity(1,1) NOT NULL, 
	TypeId tinyint NOT NULL DEFAULT 0,
	CreatedOn datetime NOT NULL DEFAULT (GETDATE()),	
	CreatedBy [nvarchar](100) NOT NULL,
	UpdatedOn datetime NOT NULL DEFAULT (GETDATE()),
	UpdatedBy [nvarchar](100) NULL,	
	IsPublished bit NOT NULL DEFAULT 0,
	IsBonus bit NOT NULL DEFAULT 0,
	Price decimal(10,2) NOT NULL DEFAULT 0,
	Title nvarchar(100) NOT NULL,
	ProductName nvarchar(100) NULL,
	Seq int NOT NULL DEFAULT 0,
	Source nvarchar(100) NULL,
	ViewCount int NOT NULL DEFAULT 0,
	Details ntext NULL
);
